/*
 Navicat MySQL Data Transfer

 Source Server         : iMenuDB
 Source Server Version : 50148
 Source Host           : 10.9.24.28
 Source Database       : iMenuDB

 Target Server Version : 50148
 File Encoding         : utf-8

 Date: 09/26/2011 17:17:44 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `imenu_course`
-- ----------------------------
DROP TABLE IF EXISTS `imenu_course`;
CREATE TABLE `imenu_course` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `menu_id` int(11) NOT NULL COMMENT '菜单Id',
  `tag_id` int(11) DEFAULT NULL COMMENT '菜品分类id',
  `name` varchar(40) DEFAULT NULL COMMENT '菜品名称',
  `price` int(11) DEFAULT NULL COMMENT '价格（分）',
  `star` int(11) DEFAULT NULL COMMENT '菜品星级',
  `recipe` varchar(45) CHARACTER SET utf8 COLLATE utf8_czech_ci DEFAULT NULL COMMENT '烹饪方式',
  `measure` int(11) DEFAULT NULL COMMENT '计量',
  `available` bit(1) DEFAULT NULL COMMENT '上架状态',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `portrait_image` varchar(100) CHARACTER SET utf8 COLLATE utf8_czech_ci DEFAULT NULL COMMENT '竖图',
  `landscape_image` varchar(100) CHARACTER SET utf8 COLLATE utf8_czech_ci DEFAULT NULL COMMENT '横图',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `deleted` bit(1) DEFAULT NULL COMMENT '删除标记',
  PRIMARY KEY (`id`),
  KEY `tag_id` (`tag_id`),
  KEY `menu_id` (`menu_id`) USING BTREE,
  CONSTRAINT `imenu_course_ibfk_1` FOREIGN KEY (`menu_id`) REFERENCES `imenu_menu` (`id`),
  CONSTRAINT `imenu_course_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `imenu_tag` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='菜品表';

-- ----------------------------
--  Records of `imenu_course`
-- ----------------------------
BEGIN;
INSERT INTO `imenu_course` VALUES ('1', '6', '2', '水晶牛肉', '26', null, '文火炖熟，放凉刀切', '1', b'1', '2011-08-25 11:42:55', 'course_1_portrait.JPG', 'course_1_landscape.JPG', '2011-06-24 11:08:15', null), ('2', '6', '1', '肚皮舞', '32', null, '刀切', '1', b'1', '2011-08-10 11:32:57', 'course_2_portrait.JPG', 'course_2_landscape.JPG', '2011-06-24 13:27:45', null), ('3', '6', '1', '橙香辣白菜', '12', null, '腌制', '1', b'1', '2011-08-10 11:34:17', 'course_3_portrait.JPG', 'course_3_landscape.JPG', '2011-06-24 13:29:59', null), ('4', '15', '1', '酱紫上海青', '18', null, '腌制', '1', b'1', '2011-08-12 17:35:44', 'course_4_portrait.JPG', 'course_4_landscape.JPG', '2011-06-27 14:43:00', null), ('5', '15', '1', '橙香辣白菜', '17', null, '腌制', '1', b'1', '2011-08-12 17:36:24', 'course_5_portrait.JPG', 'course_5_landscape.JPG', '2011-06-27 14:51:46', null), ('6', '6', '1', '酱紫上海青', '17', null, '腌制', '1', b'1', '2011-08-10 11:35:21', 'course_6_portrait.JPG', 'course_6_landscape.JPG', '2011-06-27 15:09:20', null), ('7', '6', '2', '蒜苔鱿鱼招风耳', '33', '1', '炒', '1', b'1', '2011-08-10 11:36:16', 'course_7_portrait.JPG', 'course_7_landscape.JPG', '2011-07-11 11:55:22', null), ('8', '6', '2', '响油红虾', '48', '3', '煎', '1', b'1', '2011-08-10 11:37:54', 'course_8_portrait.JPG', 'course_8_landscape.JPG', '2011-07-11 11:58:40', null), ('9', '6', '3', '藏鸡清蒸', '68', '2', '蒸', '1', b'1', '2011-08-10 11:39:13', 'course_9_portrait.JPG', 'course_9_landscape.JPG', '2011-07-12 11:47:34', null), ('10', '6', '3', '格桑花小炒', '18', '2', '炒', '1', b'1', '2011-08-10 11:40:12', 'course_10_portrait.JPG', 'course_10_landscape.JPG', '2011-07-12 11:48:55', null), ('11', '11', '1', '炸小黄鱼', '28', '1', '油炸', '1', b'0', '2011-08-12 17:32:01', 'course_11_portrait.JPG', 'course_11_landscape.JPG', '2011-08-10 13:22:37', null), ('12', '11', '6', '千岛湖沙拉', '23', '3', '沙拉', '1', b'0', '2011-08-12 17:32:44', 'course_12_portrait.JPG', 'course_12_landscape.JPG', '2011-08-10 13:26:06', null), ('13', '6', '1', '冷冷情丝', '19', null, '凉拌、冰镇', null, b'1', '2011-08-12 17:17:55', 'course_13_portrait.JPG', 'course_13_landscape.JPG', '2011-08-12 17:12:30', null), ('14', '6', '3', '落羽凤', '19', null, '生拌', null, b'1', '2011-08-12 17:17:59', 'course_14_portrait.JPG', 'course_14_landscape.JPG', '2011-08-12 17:14:31', null), ('15', '6', '2', '清炒小蔬', '18', null, '清炒', null, b'1', '2011-08-12 17:18:02', 'course_15_portrait.JPG', 'course_15_landscape.JPG', '2011-08-12 17:13:28', null);
COMMIT;

-- ----------------------------
--  Table structure for `imenu_customer`
-- ----------------------------
DROP TABLE IF EXISTS `imenu_customer`;
CREATE TABLE `imenu_customer` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `nickname` varchar(20) COLLATE utf8_czech_ci DEFAULT NULL,
  `mobile` varchar(20) COLLATE utf8_czech_ci DEFAULT NULL,
  `alipay_name` varchar(100) COLLATE utf8_czech_ci DEFAULT NULL,
  `device_id` varchar(100) COLLATE utf8_czech_ci DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

-- ----------------------------
--  Records of `imenu_customer`
-- ----------------------------
BEGIN;
INSERT INTO `imenu_customer` VALUES ('1', '云子', '15068851851', 'yunzi@taobao.com', 'c5c10ae65c61ff3ef881be8a8e05fceaa6feda97'), ('2', 'mellon', '15068851851', 'yunzi@taboo.com', 'B42DFE16-7BFD-5167-B167-6DF7B1E645BB'), ('3', '飞朋', '18667170910', 'feipeng.zxl@taobao.com', '07742da564f2024015b6d6cfc477f95f031e3be9'), ('5', 'Mellon', null, null, '000000000000000'), ('6', 'Mellon', null, null, '357988023376259');
COMMIT;

-- ----------------------------
--  Table structure for `imenu_favorite`
-- ----------------------------
DROP TABLE IF EXISTS `imenu_favorite`;
CREATE TABLE `imenu_favorite` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) DEFAULT NULL,
  `menu_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `customer_id` (`customer_id`)
) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

-- ----------------------------
--  Records of `imenu_favorite`
-- ----------------------------
BEGIN;
INSERT INTO `imenu_favorite` VALUES ('8', '1', '12'), ('15', '1', '6'), ('16', '1', '11'), ('17', '1', '13'), ('10', '1', '9'), ('11', '1', '9'), ('12', '1', '7'), ('13', '1', '9'), ('14', '1', '9'), ('18', '1', '14'), ('19', '1', '15'), ('20', '1', '16'), ('21', '3', '6'), ('22', '3', '11'), ('23', '3', '12'), ('24', '3', '13'), ('25', '3', '14'), ('26', '3', '15'), ('27', '2', '6'), ('28', '2', '11'), ('29', '2', '12'), ('30', '2', '13'), ('31', '2', '14'), ('32', '2', '15'), ('33', '2', '16'), ('34', '4', '6'), ('35', '4', '11'), ('36', '4', '12'), ('37', '4', '13'), ('38', '4', '14'), ('39', '5', '6'), ('40', '5', '11'), ('41', '5', '12'), ('42', '5', '13'), ('43', '5', '14'), ('44', '6', '6'), ('45', '6', '11'), ('46', '6', '12'), ('47', '6', '13'), ('48', '6', '14'), ('49', '6', '15'), ('50', '6', '14'), ('51', '6', '13'), ('52', '6', '12'), ('53', '6', '11'), ('54', '6', '6');
COMMIT;

-- ----------------------------
--  Table structure for `imenu_lang`
-- ----------------------------
DROP TABLE IF EXISTS `imenu_lang`;
CREATE TABLE `imenu_lang` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

-- ----------------------------
--  Records of `imenu_lang`
-- ----------------------------
BEGIN;
INSERT INTO `imenu_lang` VALUES ('1', 'en'), ('2', 'zh'), ('3', 'ja');
COMMIT;

-- ----------------------------
--  Table structure for `imenu_menu`
-- ----------------------------
DROP TABLE IF EXISTS `imenu_menu`;
CREATE TABLE `imenu_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(11) NOT NULL COMMENT '店铺Id',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `image_landscape` varchar(100) CHARACTER SET utf8 COLLATE utf8_czech_ci DEFAULT NULL COMMENT '横图',
  `image_portrait` varchar(100) CHARACTER SET utf8 COLLATE utf8_czech_ci DEFAULT NULL COMMENT '竖图',
  `title` varchar(40) CHARACTER SET utf8 COLLATE utf8_czech_ci DEFAULT NULL COMMENT '菜单标题',
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_czech_ci DEFAULT NULL COMMENT '菜单名称',
  `description` text CHARACTER SET utf8 COLLATE utf8_czech_ci COMMENT '菜单描述信息',
  PRIMARY KEY (`id`),
  KEY `store_id` (`store_id`) USING HASH,
  CONSTRAINT `imenu_menu_ibfk_1` FOREIGN KEY (`store_id`) REFERENCES `imenu_store` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `imenu_menu`
-- ----------------------------
BEGIN;
INSERT INTO `imenu_menu` VALUES ('6', '1', '2011-08-25 11:43:32', 'menu_6_landscape.JPG', 'cover_6_portrait.JPG', '格桑花', '格桑花西溪锋尚店', '格桑花西溪锋尚店'), ('11', '2', '2011-08-12 17:32:44', 'menu_11_landscape.JPG', 'cover_11_portrait.JPG', '羊蝎子', '杭州羊蝎子', ''), ('12', '3', '2011-08-12 16:41:54', 'menu_12_landscape.JPG', 'cover_12_portrait.JPG', '外婆家', '外婆家联合大厦店', ''), ('13', '4', '2011-08-12 16:49:34', 'menu_13_landscape.JPG', 'cover_13_portrait.JPG', '方嘉饮食', '方嘉小厨', ''), ('14', '5', '2011-08-12 16:50:19', 'menu_14_landscape.JPG', 'cover_14_portrait.JPG', '龙生鲍鱼', '龙生鲍鱼', ''), ('15', '6', '2011-08-12 17:36:24', 'menu_15_landscape.JPG', 'cover_15_portrait.JPG', '大锅台', '杭州一店', '阿斯顿'), ('16', '7', '2011-08-12 16:52:31', 'menu_16_landscape.JPG', 'cover_16_portrait.JPG', '塘味儿', '塘味儿塘苗路店', ''), ('17', '8', '2011-08-12 16:53:41', 'menu_17_landscape.JPG', 'cover_17_portrait.JPG', '湘绅家厨', '湘绅家厨塘苗路店', ''), ('18', '9', '2011-08-12 16:56:24', 'menu_18_landscape.JPG', 'cover_18_portrait.JPG', '八月美食园', '八月美食园塘苗路店', ''), ('19', '10', '2011-08-12 16:58:04', 'menu_19_landscape.JPG', 'cover_19_portrait.JPG', '一席地', '一席地万塘路物美店', ''), ('20', '11', '2011-08-12 16:58:52', 'menu_20_landscape.JPG', 'cover_20_portrait.JPG', '台海湾', '台海湾西湖国际店', ''), ('21', '12', '2011-08-12 16:59:43', 'menu_21_landscape.JPG', 'cover_21_portrait.JPG', '豪尚豪牛排', '豪尚豪西湖国际店', ''), ('22', '13', '2011-08-12 17:00:26', 'menu_22_landscape.JPG', 'cover_22_portrait.JPG', '迪欧咖啡', '迪欧咖啡西湖国际店', ''), ('23', '14', '2011-08-12 17:01:15', 'menu_23_landscape.JPG', 'cover_23_portrait.JPG', '爱吃不吃', '工商银行西湖国际', ''), ('24', '1', '2011-08-12 16:48:32', null, 'cover_24_portrait.JPG', '格桑花', '格桑花紫金公馆店', '格桑花西溪锋尚店'), ('25', '15', '2011-08-12 16:31:07', null, 'cover_25_portrait.JPG', '云子3', '云子3', 'yunzi3');
COMMIT;

-- ----------------------------
--  Table structure for `imenu_order`
-- ----------------------------
DROP TABLE IF EXISTS `imenu_order`;
CREATE TABLE `imenu_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` tinyint(3) DEFAULT NULL COMMENT '订单状态：1 新订单 2 商家已接受 3 客户已付款 4 商家确认',
  `amount` int(11) DEFAULT NULL COMMENT '金额（分）',
  `store_id` int(11) DEFAULT NULL COMMENT '店铺Id',
  `customer_id` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL COMMENT '订单的客户标识（内容待定）',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `store_id` (`store_id`)
) ENGINE=MyISAM AUTO_INCREMENT=84 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='订单表';

-- ----------------------------
--  Records of `imenu_order`
-- ----------------------------
BEGIN;
INSERT INTO `imenu_order` VALUES ('70', '1', '28', '2', 'c5c10ae65c61ff3ef881be8a8e05fceaa6feda97', '2011-08-25 10:15:19'), ('71', '1', '55', '1', '07742da564f2024015b6d6cfc477f95f031e3be9', '2011-08-25 10:17:05'), ('72', '1', '55', '1', 'c5c10ae65c61ff3ef881be8a8e05fceaa6feda97', '2011-08-25 10:17:06'), ('74', '1', '138', '1', 'c5c10ae65c61ff3ef881be8a8e05fceaa6feda97', '2011-09-01 14:30:23'), ('75', '1', '32', '1', 'c5c10ae65c61ff3ef881be8a8e05fceaa6feda97', '2011-09-06 13:08:06'), ('76', '1', '44', '1', 'c5c10ae65c61ff3ef881be8a8e05fceaa6feda97', '2011-09-06 13:12:53'), ('77', '1', '32', '1', 'c5c10ae65c61ff3ef881be8a8e05fceaa6feda97', '2011-09-06 13:13:08'), ('78', '1', '78', '1', 'c5c10ae65c61ff3ef881be8a8e05fceaa6feda97', '2011-09-08 16:22:34'), ('79', '1', null, '1', '000000000000000', '2011-09-09 19:13:05'), ('80', '1', '213', '1', '000000000000000', '2011-09-09 19:18:39'), ('81', '1', '213', '1', '000000000000000', '2011-09-09 19:20:58'), ('82', '1', '213', '1', '000000000000000', '2011-09-09 19:21:45'), ('83', '1', '213', '1', '000000000000000', '2011-09-09 19:23:26'), ('73', '1', '60', '1', '07742da564f2024015b6d6cfc477f95f031e3be9', '2011-08-25 11:31:18');
COMMIT;

-- ----------------------------
--  Table structure for `imenu_order_item`
-- ----------------------------
DROP TABLE IF EXISTS `imenu_order_item`;
CREATE TABLE `imenu_order_item` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) DEFAULT NULL COMMENT '订单Id',
  `course_id` int(11) DEFAULT NULL COMMENT '菜品Id',
  `course_name` varchar(40) COLLATE utf8_czech_ci DEFAULT NULL COMMENT '菜名',
  `course_price` int(11) DEFAULT NULL COMMENT '价格（分）',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=422 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

-- ----------------------------
--  Records of `imenu_order_item`
-- ----------------------------
BEGIN;
INSERT INTO `imenu_order_item` VALUES ('417', '83', '15', '清炒小蔬', '18', '2011-09-09 19:23:26'), ('418', '83', '13', '冷冷情丝', '19', '2011-09-09 19:23:26'), ('419', '83', '1', '水晶牛肉', '26', '2011-09-09 19:23:26'), ('420', '83', '6', '酱紫上海青', '17', '2011-09-09 19:23:26'), ('421', '83', '8', '响油红虾', '48', '2011-09-09 19:23:26'), ('416', '83', '1', '水晶牛肉', '26', '2011-09-09 19:23:26'), ('365', '70', '11', '炸小黄鱼', '28', '2011-08-25 10:15:19'), ('366', '71', '3', '橙香辣白菜', '12', '2011-08-25 10:17:05'), ('367', '71', '6', '酱紫上海青', '17', '2011-08-25 10:17:05'), ('368', '71', '1', '水晶牛肉', '26', '2011-08-25 10:17:05'), ('369', '72', '1', '水晶牛肉', '26', '2011-08-25 10:17:06'), ('370', '72', '6', '酱紫上海青', '17', '2011-08-25 10:17:06'), ('371', '72', '3', '橙香辣白菜', '12', '2011-08-25 10:17:06'), ('372', '73', '13', '冷冷情丝', '19', '2011-08-25 11:31:18'), ('373', '73', '3', '橙香辣白菜', '12', '2011-08-25 11:31:18'), ('374', '73', '3', '橙香辣白菜', '12', '2011-08-25 11:31:18'), ('375', '73', '6', '酱紫上海青', '17', '2011-08-25 11:31:18'), ('376', '74', '2', '肚皮舞', '32', '2011-09-01 14:30:23'), ('377', '74', '6', '酱紫上海青', '17', '2011-09-01 14:30:23'), ('378', '74', '13', '冷冷情丝', '19', '2011-09-01 14:30:23'), ('379', '74', '1', '水晶牛肉', '26', '2011-09-01 14:30:23'), ('380', '74', '2', '肚皮舞', '32', '2011-09-01 14:30:23'), ('381', '74', '3', '橙香辣白菜', '12', '2011-09-01 14:30:23'), ('382', '75', '2', '肚皮舞', '32', '2011-09-06 13:08:06'), ('383', '76', '3', '橙香辣白菜', '12', '2011-09-06 13:12:53'), ('384', '76', '2', '肚皮舞', '32', '2011-09-06 13:12:53'), ('385', '77', '2', '肚皮舞', '32', '2011-09-06 13:13:08'), ('386', '78', '3', '橙香辣白菜', '12', '2011-09-08 16:22:34'), ('387', '78', '2', '肚皮舞', '32', '2011-09-08 16:22:34'), ('388', '78', '6', '酱紫上海青', '17', '2011-09-08 16:22:34'), ('389', '78', '6', '酱紫上海青', '17', '2011-09-08 16:22:34'), ('390', '80', '1', '水晶牛肉', '26', '2011-09-09 19:18:39'), ('391', '80', '15', '清炒小蔬', '18', '2011-09-09 19:18:39'), ('392', '80', '1', '水晶牛肉', '26', '2011-09-09 19:18:39'), ('393', '80', '1', '水晶牛肉', '26', '2011-09-09 19:18:39'), ('394', '80', '6', '酱紫上海青', '17', '2011-09-09 19:18:39'), ('395', '80', '8', '响油红虾', '48', '2011-09-09 19:18:39'), ('396', '80', '7', '蒜苔鱿鱼招风耳', '33', '2011-09-09 19:18:39'), ('397', '80', '13', '冷冷情丝', '19', '2011-09-09 19:18:39'), ('398', '81', '1', '水晶牛肉', '26', '2011-09-09 19:20:58'), ('399', '81', '8', '响油红虾', '48', '2011-09-09 19:20:58'), ('400', '81', '13', '冷冷情丝', '19', '2011-09-09 19:20:58'), ('401', '81', '15', '清炒小蔬', '18', '2011-09-09 19:20:58'), ('402', '81', '6', '酱紫上海青', '17', '2011-09-09 19:20:58'), ('403', '81', '1', '水晶牛肉', '26', '2011-09-09 19:20:58'), ('404', '81', '1', '水晶牛肉', '26', '2011-09-09 19:20:58'), ('405', '81', '7', '蒜苔鱿鱼招风耳', '33', '2011-09-09 19:20:58'), ('406', '82', '8', '响油红虾', '48', '2011-09-09 19:21:45'), ('407', '82', '6', '酱紫上海青', '17', '2011-09-09 19:21:45'), ('408', '82', '15', '清炒小蔬', '18', '2011-09-09 19:21:45'), ('409', '82', '1', '水晶牛肉', '26', '2011-09-09 19:21:45'), ('410', '82', '1', '水晶牛肉', '26', '2011-09-09 19:21:45'), ('411', '82', '13', '冷冷情丝', '19', '2011-09-09 19:21:45'), ('412', '82', '7', '蒜苔鱿鱼招风耳', '33', '2011-09-09 19:21:45'), ('413', '82', '1', '水晶牛肉', '26', '2011-09-09 19:21:45'), ('414', '83', '7', '蒜苔鱿鱼招风耳', '33', '2011-09-09 19:23:26'), ('415', '83', '1', '水晶牛肉', '26', '2011-09-09 19:23:26');
COMMIT;

-- ----------------------------
--  Table structure for `imenu_store`
-- ----------------------------
DROP TABLE IF EXISTS `imenu_store`;
CREATE TABLE `imenu_store` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL COMMENT '父店铺Id',
  `brand_name` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL COMMENT '品牌名',
  `store_name` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL COMMENT '店铺名',
  `address` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL COMMENT '店铺地址',
  `tel` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL COMMENT '联系电话',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `terminalId` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL COMMENT '商户的POS终端Id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='菜单店铺';

-- ----------------------------
--  Records of `imenu_store`
-- ----------------------------
BEGIN;
INSERT INTO `imenu_store` VALUES ('1', null, '格桑花', '格桑花西溪锋尚店', '文三西路西溪锋尚东侧沿河街', '15068851851', '2011-06-22 11:27:28', '01224655'), ('2', null, '羊蝎子', '羊蝎子', '门前六七树', '', '2011-06-24 14:41:02', null), ('3', null, '外婆家', '外婆家联合大厦店', '联合大厦2层', '', '2011-06-24 14:41:26', null), ('4', null, '方嘉', '方嘉小厨', '紫金公馆', '', '2011-06-24 15:13:32', null), ('5', null, '龙生鲍鱼', '龙生鲍鱼', '一望二三里', '', '2011-06-24 15:14:17', null), ('6', null, '大锅台', '大锅台杭州一店', '绿洲湾', '', '2011-06-27 14:49:43', null), ('7', null, '塘味儿', '塘味儿塘苗路店', '塘苗路18号', '', '2011-06-28 17:14:49', null), ('8', null, '湘绅家厨', '湘绅家厨塘苗路店', '塘苗路20号', '', '2011-06-28 17:16:18', null), ('9', null, '八月美食园', '八月塘苗路店', '塘苗路19号', '', '2011-06-28 17:17:15', null), ('10', null, '一席地', '一席地万塘路物美店', '万塘路物美', '', '2011-06-28 17:17:53', null), ('11', null, '台海湾', '台海湾西湖国际店', '文二路西湖国际大厦裙楼一层', '', '2011-06-28 17:18:32', null), ('12', null, '豪尚豪牛排', '豪尚豪牛排西湖国际店', '西湖国际裙楼1层', '', '2011-06-28 17:24:52', null), ('13', null, '迪欧咖啡', '迪欧咖啡西湖国际店', '西湖国际裙楼一层', '', '2011-06-28 17:25:24', null), ('14', null, '爱吃不吃', '工商银行', '西湖国际一层', '', '2011-06-28 17:25:45', null), ('15', null, 'yunzi3', 'yunzi3', 'as', 'a', null, 'a');
COMMIT;

-- ----------------------------
--  Table structure for `imenu_tag`
-- ----------------------------
DROP TABLE IF EXISTS `imenu_tag`;
CREATE TABLE `imenu_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(11) NOT NULL COMMENT '店铺Id',
  `name` varchar(10) COLLATE utf8_czech_ci NOT NULL COMMENT '分类名称',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `description` text COLLATE utf8_czech_ci COMMENT '描述信息',
  PRIMARY KEY (`id`),
  KEY `store_id` (`store_id`) USING HASH,
  CONSTRAINT `imenu_tag_ibfk_1` FOREIGN KEY (`store_id`) REFERENCES `imenu_store` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='菜品分类';

-- ----------------------------
--  Records of `imenu_tag`
-- ----------------------------
BEGIN;
INSERT INTO `imenu_tag` VALUES ('1', '1', '凉菜', '2011-06-22 13:45:49', ''), ('2', '1', '炒菜', '2011-06-22 13:46:16', ''), ('3', '1', '特色菜', '2011-06-22 13:46:25', ''), ('4', '1', '酒水', '2011-06-22 13:46:38', ''), ('5', '1', '主食', '2011-06-22 13:46:52', ''), ('6', '2', '凉菜', '2011-08-10 13:23:18', ''), ('7', '3', '凉菜', '2011-08-10 13:23:24', ''), ('8', '4', '凉菜', '2011-08-10 13:23:29', ''), ('9', '5', '凉菜', '2011-08-10 13:23:35', '');
COMMIT;

-- ----------------------------
--  Table structure for `imenu_user`
-- ----------------------------
DROP TABLE IF EXISTS `imenu_user`;
CREATE TABLE `imenu_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(11) DEFAULT NULL COMMENT '店铺Id',
  `username` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL COMMENT '用户名',
  `password` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL COMMENT '登录密码',
  PRIMARY KEY (`id`),
  KEY `store_id` (`store_id`),
  CONSTRAINT `imenu_user_ibfk_1` FOREIGN KEY (`store_id`) REFERENCES `imenu_store` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='菜单用户';

-- ----------------------------
--  Records of `imenu_user`
-- ----------------------------
BEGIN;
INSERT INTO `imenu_user` VALUES ('1', '1', 'mellon1', 'mellon1'), ('2', '2', 'mellon2', 'mellon2'), ('3', '3', 'mellon3', 'mellon3'), ('4', '4', 'mellon4', 'mellon4'), ('5', '5', 'mellon5', 'mellon5'), ('6', '6', 'mellon6', 'mellon6'), ('7', '7', 'mellon7', 'mellon7'), ('8', '8', 'mellon8', 'mellon8'), ('9', '9', 'mellon9', 'mellon9'), ('10', '10', 'mellon10', 'mellon10'), ('11', '11', 'mellon11', 'mellon11'), ('12', '12', 'mellon12', 'mellon12'), ('13', '13', 'mellon13', 'mellon13'), ('14', '14', 'mellon14', 'mellon14'), ('15', '14', 'mellon15', 'mellon15'), ('16', '14', 'mellon16', 'mellon16');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
